Viewing 15 posts - 30,316 through 30,330 (of 39,821 total)
Not sure what you mean about the stored procedure in the table.
You don't need the name of the stored procedure to call it, you can send in parameters in order....
December 14, 2007 at 8:03 am
This has happened at times in 2000, and as mentioned above, the only thing to do is stop and restart SQL Server.
December 14, 2007 at 7:57 am
I would not link the servers. Often people with rights to query staging do not have rights to production (nor should they). It's a potential security hole.
Instead I'd give rights...
December 14, 2007 at 7:19 am
I hadn't mentioned writing, but it is something I'd ask for if it's an unusual request. Thanks for mentioning and glad that people are thinking of it. I'd also note...
December 14, 2007 at 7:17 am
I think there are always jobs. I've seen reports this week that IT hiring was strong in the US and also that it was not doing well. Overall you can...
December 14, 2007 at 7:15 am
I'd use Karthik's solution and then be sure you get them into a version control system. Ideally you are checking them out of some SCC and then editing them before...
December 14, 2007 at 6:43 am
Constraints internal to the table require scripting. If there are FKs to other tables, are you importing them?
Andras mentions scripting it out, probably the easiest way, recreate the table in...
December 14, 2007 at 6:42 am
I don't know of any software like this for end -users. Many packages will export to Word or HTML, so maybe you can keep a copy in one of those...
December 14, 2007 at 6:38 am
The only way to do this that I think of right now is with Dynamic SQL, which I don't recommend.
I'd just build in the time it takes to make the...
December 14, 2007 at 6:37 am
You must be adding data to the mdf, as mentioned above. That's why it grows. To stop it from growing, stop adding data.
You should have an idea of growth and...
December 13, 2007 at 9:32 pm
I'd use Sergiy's method, but if you don't want nulls, use
if @x is not null
instead. It's cleaner.
December 13, 2007 at 9:30 pm
Are you connecting with TCP/IP? It's possible that SQL was installed without TCPIP. You can check the beginning of the SQL Server error log to see which IPs it's listening...
December 13, 2007 at 9:28 pm
The proxy needs to know to forward port 1500 to the outside IP. I believe by default this is not the case with most proxy servers.
Be sure their firewall also...
December 13, 2007 at 9:26 pm
It will never happen. When will we eliminate shoplifting? Never. As long as we want the richness and flexibility, there will be issues.
What we can do is do a better...
December 13, 2007 at 8:44 am
Do you mean you have a Word document you want linked with a record?
You can store the Word file in an image column in SQL Server, but you'd need to...
December 13, 2007 at 8:41 am
Viewing 15 posts - 30,316 through 30,330 (of 39,821 total)