I have a very long T-sql script, it is a single batch, something like DECLARE variables select into temptable... cursor... insert... update.. as I run the script I have (1 row(s) affected) (5 row(s) affected) [...] ERROR (2 row(s) affected) etc... I would like to run step by step the script to identify which is the command...
I have a .sql file I need to enter in to my database, but I can't find how to do it. I'm using SQL Server Management Studio R2, but haven't found any options on how to add it. When I try to attach it, I'm told that this file isn't a primary database file, so I can't do it... EDIT: okay, I had the script execute. That worked. ...
Hello I've just installed SQL Server 2005 Express and I'm trying to login to Management Studio but I don't know what the "Server Name" is to be able to login. I've tried: localhost\SQLEXPRESS 127.0.0.1\SQLEXPRESS SQLEXPRESS <computer name>\SQLEXPRESS <username>\SQLEXPRESS The authentication mode is Windows Authentication. The error...